TelOldStripped) - Length (L@#5))), N@#4 & Right (TelOldStripped, Length (TelOldStripped) - L
N@#2.........N@#6 look up the new prefix.
Finally TelNew computes the new phone number and formats it,
C@mments indicates possible errors. Field names have been
@tted to prevent a naming conflict with yourF
other fields. If you happen to have a field with the same name make a change.
It is convenient to define TelOld as an extra calc field set equal to your phone field. This way you can convert more than one phon
Copyright 1995, J. J. Lodder
Copyright 1995, J. J. Lodder
TelNew without the need for a relookup.
After Oct 10 you merely have to omit the superfluous F~calc fields, change TelNew from a calculation field to a text field (and rename it appropriately) and live happily ever after.
e and create the same fields there.
K@#2.........K@#6 are calculation fields made equal to a part of a
stripped phone number, to be looked up in the PTT data.
The SlowMac version stores an intermediate result.
Next there are 10 lookup fields. Do set lookup to get the definitions. Do not forget to set Use 0 in case of no match, correct conversion depends on this!
L@#2.........L@#6 look up the corresponding old area co
K@#5B
Left (TelOldStripped,5)
K@#6B
Left (TelOldStripped,6)
L@#2B
PTTconvDataK
L@#3B
PTTconvDataK
L@#4B
N@#2B
PTTconvDataK
N@#3B
PTTconvDataK
N@#4B
PTTconvDataK
N@#5B
PTTconvDataK
N@#6B
PTTconvDataK
TelNewB
TelNew
C@mment
Copyright 1995, J. J. Lodder
Id@ntL@bel
TelOld
A Layout #6B
TelOld
Id@ntL@bel
K@#4S
Empty!
TelOld
TelOld
e field without duplication of the conversion machinery.
To force conversion of existing records do a relookup on TelOld. New phone numbers entered in TelOld will appear immediately in TelNew without the need H
for a relookup.
After Oct 10 you merely have to omit the superfluous calc and lookup fields, change TelNew from a calculation field to a text field (and rename it appropriately) and live happily ever after.